2015-07-16 - 20093 - Break Fix - WMS740-Uninvoice SO report failure #CrystalReportsSupport

Break Fix

20093 - WMS740-Uninvoice SO report failure

Problem Summary

Need to fix WMS740 - Uninvoice SO report failure issue in BI production.

Admin Info

Purpose
 Need to fix WMS740 - Uninvoice SO report failure issue in BI production.
Requested by
 Judy Sanchez
Issue Date
 07-16-2015
Resolved by
 Dhananjay G
Resolved Date
 08-27-2015
Document Status
 WIP

Detailed Problem Description

This WMS740 report is used by Invoicing Department daily as resource to determine invoices that need to be generated for SNC orders.
It has mysteriously failed randomly for a long time. I rescheduled the recurring and set it to notify me if it fails. It wouldn’t even notify me…
Can you or your team please help since I am out of solutions.
WMS740.png

Solution Analysis and Recommendations

1. Need to analysis on WMS740 report in BI Production.
2. Need to check the scheduling options in BI Launchpad.
3. Need to recommended OSS Note 1900005 related to this issue.
4. Need to update the data sources in the report.
5. Need to investigate destination path causing the issue in the schedule options.

Resolution

1. Need to analysis on WMS740 report in BI Production.
2. Need to check the scheduling options in BI Launchpad.
3. Need to check OSS Notes related to this issue.
4. Need to update the data sources in the report.
5. Identified that the issue is caused by the file name 'GSCI005.csv' in the destination path.
6. The reason behind is the file is being locked in the background at the server level causing the failure of both the reports GSCI005- DD Passed not PGRd and WMS740 report.

Test Plan

Test ID
 Test Scenario
 Expected Results
1
 Report Format.
 Should be as per NEC crystal standard checklist.
2
 Schedule the Report in NEC BI Launch Pad.
 Report should execute successfully in NEC BI Launch Pad.

Release Information

None